Client Ledger

The Client Ledger report shows the detail WIP and AR transactions by client. The report shows a balance forward as of the starting date entered. The report includes detail of all WIP and AR transactions after that balance forward to the ending date entered.

Permissions Required for this Report

In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:

• Security group profile > Functional rights > Reports > Shared Library > Shared Views
• Security group profile > Functional rights > Reports > Firm Library > Custom
• Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
• Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
• Security group profile > Functional rights > Reports > Firm Library > <report name>
• Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients

Reports in Foundation that are Comparable

In Practice Management, the comparable report is the Client Ledger Report. In Practice Advantage, there is no comparable report.

Report Specifications

The following report options and filters are available to determine the report contents.

Options and Settings
Option	Setting	Description
Show Invoice Description	Yes/No	Includes or excludes the invoice description column.
Hide Comma	Yes/No	Includes or excludes commas in numbers.
Hide Penny	Yes/No	Includes or excludes pennies in amounts.
Include Deleted Clients	Yes/No	Includes or excludes deleted client information.

Default Filters
Field Name	Operator	Value
Transaction Date	Between	First Day Of Current Fiscal Year, Last Day Of Current Fiscal Year

Optional Filters
Available Fields
Accounting Period Date	Client ID.Sub ID	Payments/Adjustments
Amount	Client Name	Posted Date
Applied	Client Office	Primary Partner
Billed	Client Primary Service Type	Progress
Business Code	Client Region	Return Group
Category ID	Client Sub ID	Service Code ID
Client	Client Type	Service Code Name
Client – Principal	Description	Staff ID
Client Bill Manager	Financial Reporting Client Group	Subcategory ID
Client Billing Group	Hours	Subcategory Name
Client Business Unit	Line of Business	Tax Type
Client ID	Manager	Transaction Date

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Grouping
Available Fields
Business Code	Client ID.Sub ID	Manager
Category ID	Client Name	Primary Partner
Category Name	Client Office	Return Group
Client	Client Primary Service Type	Service Code ID
Client – Principal	Client Region	Sort Name
Client Bill Manager	Client Sub ID	Subcategory ID
Client Billing Group	Client Type	Subcategory Name
Client Business Unit	Financial Reporting Client Group	Tax Type
Client ID	Line of Business

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Sorting
Available Fields
Amount	Client Name	Progress
Applied	Date	Service Code
Billed	Hours	Staff ID
Client	Payments/Adjustments

Report Fields

The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.

Report Fields
Field	Description
Client	The client name, and client ID, and sub-ID
Client Name	The client name.
Balance Forward	The balance for the WIP and AR prior to the beginning date of the report.
Date	The date of the transaction.
Description	The description of the transaction type.
Staff ID	The staff ID of the person assigned to the WIP transaction.
Service Code	The service code assigned to the transaction (for WIP transactions only).
Hours	The total hours tied to the transaction (for WIP transactions only).
Amount	The total amount of the WIP transaction.
Progress	The total amount of progress billed for the transaction (for WIP transactions only).
Applied	The total amount of progress applied to the transaction (for WIP transactions only).
Balance	The WIP balance after each transaction.
Billed	The total amount billed for the transaction (for AR transactions only).
Payments/Adjustments	The total amount of payments and adjustments for the transaction (for AR transactions only).
Balance	The AR balance after each transaction.

Client Ledger Sample Report